Using Object-Oriented Principles to Optimize Update Propagation to Materialized Views
نویسندگان
چکیده
View materialization is known to be a valuable technique for performance optimization in relational databases, and much work has been done addressing the problem of consistently maintaining relational views under update operations. However, little progress has been made thus far regarding the topic of view materialization in objectoriented databases (OODBs). In this paper, we demonstrate that there are several significant differences between the relational and object-oriented paradigms that can be exploited when addressing the object-oriented view materialization problem. We use the subsumption relationships between classes to identify branches of classes to which we do not need to propagate updates. Similarly, we use encapsulated interfaces combined with the fact that any unique database property is inherited from a single location to provide a “registration/notification” service for optimizing incremental view updates. We also report results from the experimental studies we have run on the MultiView system measuring the impact of these optimization strategies.
منابع مشابه
Using Object - Oriented Principles to Optimize Update
View materialization is known to be a valuable technique for performance optimization in relational databases, and much work has been done addressing the problem of consistently maintaining relational views under update operations. However, little progress has been made thus far regarding the topic of view materialization in object-oriented databases (OODBs). In this paper, we demonstrate that ...
متن کاملReduction of Update Propagation Overhead for Data Warehousing Incorporating OODBs
Since the requirement of data warehouse is increasing, it is necessary to develop eflcient mechanisms for data warehouses incorporating various kinds of database systems. Essentially, materialized views are used for data warehouses and various methods for relational databases have been developed. In this paper, we will first discuss a method to realize materialized views for object-on’ented dat...
متن کاملAugmented Inherited Multi-Index Structure for Maintenaince of Materialized Path Query Views
Materialized complex object-oriented views are a promising technique for the integration of heterogeneous databases and the development of powerful data warehousing systems. Path query views are virtual classes formed from selection queries that specify a predicate upon the value of an aggregation hierarchy path. The primary diierence between previous work regarding OODB indexing and the eecien...
متن کاملUpdate Propagation in Chimera, an Active DOOD Language
Propagating updates is an important task to be performed within many database services such as integrity checking, maintenance of materialized views, and condition monitoring. This paper is concerned with the propagation of updates in an active DOOD language. The approach proposed is to make use of Chimera triggers for computing induced updates. It will be shown how a subset of Chimera's deduct...
متن کاملView Management Issues in Object - Oriented Databases
In database terminology, a view is a query that is stored and given a name by which it can be used in other queries. Views are an established technique for virtually restructuring data, classes, and schemata so as to meet the needs of specific applications or users, for integrating heterogeneous and distributed systems (for example, data warehouse systems), and for achieving interoperability by...
متن کامل